USE [BS5]

BEGIN TRANSACTION
GO
	UPDATE Voucher SET StationFromID = 99 WHERE StationFromID = 1 AND VoucherNo NOT LIKE 'BR-%'
	UPDATE Voucher SET StationToID = 99 WHERE StationToID = 1 AND VoucherNo NOT LIKE 'BR-%'
GO
COMMIT

------------------------------------------------------------------------------------------------------